Indexes are optional structures associated with tables. You can create indexes on one or more columns of a table to speed SQL statement execution on that table.
Table indexes are managed on the Indexes tab of the Table Designer. Just simply click on an index field for editing. By using the toolbar below, you can create new, edit and delete the selected index field.
Add Index
To add a table index
- Open the table in the Table Designer.
- Open the Indexes tab.
- Click the
Add Index from the toolbar.
- Edit index properties.
Edit Index
To edit a table index
- Open the table in the Table Designer.
- Open the Indexes tab.
- Just simply click on the index to edit.
Delete Index
To delete a table index
- Open the table in the Table Designer.
- Open the Indexes tab.
- Click the
Delete Index from the toolbar.
- Confirm deleting in the dialog window.
See also:
Setting Index Properties